You can use this database to maintain school employee data such as hire date, salary, department, and grade. You can also include personal information.
How to use this solution
You can use the Phone Dialing feature to call the employee or the emergency contact person. Click the phone icon beside either field. See the FileMaker Pro documentation for more information about setting up Phone Dialing.
How to customize this solution
You can create a layout that includes your schoB
ol logo and print faculty identification badges.
You could change the field names to customize this database to keep track of employees of any type of business.
@]A Form View
A List View
Faculty List
Information
Report Menu
Avery 5160
SalaryB
Soc Sec NumberB
X1Please enter a number in the form of 000-00-0000.
< ) = 11 )
< ) )
Date of HireB
DepartmentB
Emergency ContactB
Emergency PhoneB
BA Last NameB
InfoB
Created ByB
GeorgeO
44 Hummingbird Ter.P
San CarlosQ
94070U
415-555-6127X
05/04/95Y
10/19/95i
Moved from New York early 1990.p
9/18/50z
Lecturer{
37000|
123-45-6789}
8/9/90~
Mathematics
Regina Perry
415-555-6163
Perry
DavidO
512 Charmichael St.P
Menlo ParkQ
94026U
415-555-1212X
08/19/95Y
10/1/95i
5/8/60z
Teacher{
26000|
888-88-8888}
7/26/91~
Music
Sandra Brigham
415-555-4329
Brigham
Sort by Last Name
Sort by Faculty Type
Sort by Department
Faculty List
Avery 5160
Open Script
Dial Home Phone
Dial Emergency Phone
A Form ViewB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
A List ViewB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Emergency Phone
Emergency Contact
Date of Birth
Phone
ZIP Code
Address
Personal8
Emerg Phone
Emerg Contact
Date of Birth
Phone
ZIP Code
Address
Personal
Notes
Salary
Date of Hire
Social Security #
Grade
Department
School
Faculty Type
x Last Name
First Name
Faculty ID
Enter data for Faculty
Close
View As
View As
Reports
Record
Delete
Record
Record
Your Own
Button
Your Own
Button
Faculty ListB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
PhoneX
GradeY
DepartmentZ
Faculty Type[ Last Name\
First Nameg2Click to see more information for a Faculty Memberh
Infoi
Closej
View As
Formk
View As
Listl
Reportsm
Recordn
Delete
Recordo
Recordp
Your Own
Buttonq
Your Own
Button
InformationB
Yesfter
Noarter
Yesfter
Noarter
Yesfter
Noarter
Phone
Department
Faculty Type
M Last Name
First Name
Grade
Page ##
Faculty List
Close
View As
Phone
Department
Faculty Type
M Last Name
First Name
Grade
Page ##
Faculty List
Close
View As
View As
Reports
Your Own
Button
$r N^
Report MenuB
P&Information about the Faculty databaseQ
Info for this SolutionS
InfoT
CloseU
View As
FormV
View As
ListW
ReportsX
Your Own
Button
View As
FormV
View As
ListW
ReportsX
Your Own
Button
Your Own
ReportB
Your Own
ReportC
Avery 5160D
Faculty ListL>Click on any of these buttons to preview the respective reportM
Select a reportN
InfoO
CloseP
View As
FormQ
View As
ListR
ReportsS
Your Own
Button
on any of these buttons to preview the respective reportM
Select a reportN
InfoO
CloseP
View As
FormQ
View As
ListR
ReportsS
Your Own
Button
Avery 5160B
ABAE>> <<
ABEC>>
ABAP>>
ABBA>>, <<
ABBB>> <<
ABBC>>C
Reports
InfoI
CloseJ
View As
FormK
View As
ListL
ReportsM
Your Own
Button
Yesfter
Noarter
Helvetica
Geneva
Times
Times New Roman
Arial
MS Sans Serif
Terminal
Arial MT Condensed Light
Sort by Last Name
Faculty List
Avery 5160
Sort by Faculty Type
Sort by Department
Open Script
Dial Home Phone
Cancel
Specify Field
Use Dialing Preferences
Phone Number
Field Value
Number
Dial Emergency Phone
)=400
Cancel
You did not enter any find criteria; all records will be displayed.C+